Education and Services Hub

Course Title:

Course ID:

150424 0701 1415ESH

Course Dates :

15/Apr/2024

 To

19/Apr/2024

Course Duration :

5

Course Location:

London

United Kingdom

Course Fees GBP £ :

Primary Price

£4,555.99

VAT may vary depending on the country where the course or workshop is held

Course Fees USD $:

Advisory Price

$5,829.37

VAT may vary depending on the country where the course or workshop is held

Course Category:

NGO Programmes

Artificial Intelligence (NT)

Course Certified By:

* Professional Training and CPD Programs
* Executive Diploma Certificate
* Executive Masters Certificate

* ESHub CPD
* LondonUni
* Others

United Kingdom

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.

Course Information

Introduction

Welcome to the Financial Modelling using Excel Training Course designed specifically for Non-Governmental Organizations (NGOs).
In this comprehensive five-day course, participants will delve into the world of financial modelling using Excel, gaining essential skills and knowledge to effectively analyse, plan, and forecast financial data.
Through hands-on exercises and real-world examples, attendees will enhance their proficiency in financial modelling techniques, empowering them to make informed decisions and drive organizational success.
Join us for this immersive five-day course and unlock the power of financial modelling using Excel to drive sustainable growth and impact in your NGO.

Objectives

• Equip participants with fundamental concepts and principles of financial modelling.
• Provide hands-on training on utilizing Excel for building robust financial models.
• Enable participants to create accurate forecasts and scenario analyses to support strategic decision-making.
• Enhance participants' ability to interpret and communicate financial information effectively.
• Foster a collaborative learning environment where participants can exchange ideas and best practices.

Who Should Attend?

This course is ideal for professionals working in NGOs, including:
• Finance Managers
• Program Managers
• Project Officers
• Financial Analysts
• Grant Managers
• Budget Officers
• Operations Managers
• Executives involved in financial planning and analysis.

Training Method

• Pre-assessment
• Live group instruction
• Use of real-world examples, case studies and exercises
• Interactive participation and discussion
• Power point presentation, LCD and flip chart
• Group activities and tests
• Each participant receives a 7” Tablet containing a copy of the presentation, slides and handouts
• Post-assessment

Program Support

This program is supported by:
* Interactive discussions
* Role-play
* Case studies and highlight the techniques available to the participants.

Daily Agenda

The course agenda will be as follows:
• Technical Session 08.30-10.00 am
• Coffee Break 10.00-10.15 am
• Technical Session 10.15-12.15 noon
• Coffee Break 12.15-12.45 pm
• Technical Session 12.45-02.30 pm
• Course Ends 02.30 pm

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.

Week 1

Day 1:
Financial Modelling Fundamentals
• Introduction to Financial Modelling
• Understanding Excel Functions for Financial Modelling
• Building a Basic Financial Model: Income Statement
• Sensitivity Analysis and Scenario Planning

Day 2:
Advanced Excel Techniques for Financial Modelling
• Advanced Excel Functions for Financial Modelling
• Building a Cash Flow Statement
• Introduction to Macros for Automation
• Data Validation and Protection

Day 3:
Forecasting and Projection Techniques
• Time Series Analysis for Forecasting
• Building a Balance Sheet Model
• Forecasting Revenue and Expenses
• Monte Carlo Simulation for Risk Analysis

Day 4:
Financial Modelling Best Practices
• Model Auditing and Error Checking
• Documenting and Presenting Financial Models
• Incorporating Sensitivity Analysis in Models
• Model Optimization Techniques

Day 5:
Case Studies and Practical Applications
• Case Study Analysis: Real-world NGO Financial Modelling
• Group Project: Building a Comprehensive Financial Model
• Presentation of Group Projects and Peer Feedback
• Q&A Session and Course Wrap-up

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.